<?php
/*
  $Id$

  osCommerce, Open Source E-Commerce Solutions
  http://www.oscommerce.com

  Copyright (c) 2010 osCommerce

  Released under the GNU General Public License
*/

class bm_categories {
    var $code = 'bm_categories';
    var $group = 'boxes';
    var $title;
    var $description;
    var $sort_order;
    var $enabled = false;

    function bm_categories() {
        $this->title = MODULE_BOXES_CATEGORIES_TITLE;
        $this->description = MODULE_BOXES_CATEGORIES_DESCRIPTION;

        if ( defined('MODULE_BOXES_CATEGORIES_STATUS') ) {
            $this->sort_order = MODULE_BOXES_CATEGORIES_SORT_ORDER;
            $this->enabled = (MODULE_BOXES_CATEGORIES_STATUS == 'True');

            $this->group = ((MODULE_BOXES_CATEGORIES_CONTENT_PLACEMENT == 'Left Column') ? 'boxes_column_left' : 'boxes_column_right');
        }
    }

    function tep_show_category($counter) {
        global $tree, $categories_string, $cPath_array;

        for ($i=0; $i<$tree[$counter]['level']; $i++) {
            $categories_string .= "&nbsp;&nbsp;";
        }

        $categories_string .= '<a href="';

        if ($tree[$counter]['parent'] == 0) {
            $cPath_new = 'cPath=' . $counter;
        } else {
            $cPath_new = 'cPath=' . $tree[$counter]['path'];
        }

        $categories_string .= tep_href_link(FILENAME_DEFAULT, $cPath_new) . '">';

        if (isset($cPath_array) && in_array($counter, $cPath_array)) {
            $categories_string .= '<strong>';
        }

// display category name
        $categories_string .= $tree[$counter]['name'];

        if (isset($cPath_array) && in_array($counter, $cPath_array)) {
            $categories_string .= '</strong>';
        }

        if (tep_has_category_subcategories($counter)) {
            $categories_string .= '-&gt;';
        }

        $categories_string .= '</a>';

        if (SHOW_COUNTS == 'true') {
            $products_in_category = tep_count_products_in_category($counter);
            if ($products_in_category > 0) {
                $categories_string .= '&nbsp;(' . $products_in_category . ')';
            }
        }

        $categories_string .= '<br />';

        if ($tree[$counter]['next_id'] != false) {
            $this->tep_show_category($tree[$counter]['next_id']);
        }
    }

//
//    function tep_show_category($counter) {
//        global $tree, $categories_string, $cPath_array;
//        static $count = 0;
//
//        if ($tree[$counter]['parent'] == 0) {
//            $categories_string .= '<ul class="id_' . ++$count . ' mainmenu">';
//            $cPath_new = 'cPath=' . $counter;
//            $categories_string .= '<a href="';
//            $categories_string .= tep_href_link(FILENAME_DEFAULT, $cPath_new) . '">';
//            $categories_string .= $tree[$counter]['name'];
//            $categories_string .= '</a>';
//            $categories_string .= '</ul>';
//        } else {
//            $cPath_new = 'cPath=' . $tree[$counter]['path'];
//            $categories_string .= '<script>$(".id_' . $tree[$counter]['parent'] . '").append("<li class=\\"submainmenu\\" id=\\"id_' . $tree[$counter]['parent'] . '\\"><a href=\\"' . tep_href_link(FILENAME_DEFAULT, $cPath_new) . '\\">' . $tree[$counter]['name'] . '</a></li>");</script>';
//        }
//
//        if ($tree[$counter]['next_id'] != false) {
//            $this->tep_show_category($tree[$counter]['next_id']);
//        }
//    }

    function  single_genealogy($category,  $level  =  0){
        global $tree, $categories_string, $languages_id;
        // the sons of the current node = the IDs that are matched with this parentid
        $q  =  "select c.categories_id, cd.categories_name, c.parent_id from " . TABLE_CATEGORIES . " c, " . TABLE_CATEGORIES_DESCRIPTION . " cd
             where c.parent_id ='".$category."' and c.categories_id = cd.categories_id and cd.language_id='" . (int)$languages_id ."' order by sort_order , cd.categories_name";
        $r  =  mysql_query($q);  //or  die/mail/echo  mysql_error()
        $level++;
        $categories_string .= "<ul class='mainmenu_". $level . "'>";
        if($level == 1) {
            $categories_string .= "<li class='mainmenu_2'><a href=\"http://localhost/oscommerce/index.php\">Home Page</a></li>";
        }

        while($d  =  mysql_fetch_row($r)){
            $cPath_new = 'cPath='.$d[0];
            $categories_string .=  '<li class=mainmenu_'. ($level+1) .'\'><a href='.tep_href_link(FILENAME_DEFAULT, $cPath_new).'>'.$d[1].'</a>';
            //displaying  current  node  :  $d[1]
            //recursive  call  :
            $this->single_genealogy($d[0],  $level);
            echo "</li>";
        }
        $categories_string .= "</ul>";
    }

    function getData() {
        global $categories_string;

        $this->single_genealogy($categories_string,  $level  =  0);

        $data = '<div class="menu">'  . $categories_string . '</div>';

        return $data;
    }

    function execute() {
        global $SID, $oscTemplate;

        if ((USE_CACHE == 'true') && empty($SID)) {
            $output = tep_cache_categories_box();
        } else {
            $output = $this->getData();
        }

        $oscTemplate->addBlock($output, $this->group);
    }

    function isEnabled() {
        return $this->enabled;
    }

    function check() {
        return defined('MODULE_BOXES_CATEGORIES_STATUS');
    }

    function install() {
        tep_db_query("insert into " . TABLE_CONFIGURATION . " (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, set_function, date_added) values ('Enable Categories Module', 'MODULE_BOXES_CATEGORIES_STATUS', 'True', 'Do you want to add the module to your shop?', '6', '1', 'tep_cfg_select_option(array(\'True\', \'False\'), ', now())");
        tep_db_query("insert into " . TABLE_CONFIGURATION . " (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, set_function, date_added) values ('Content Placement', 'MODULE_BOXES_CATEGORIES_CONTENT_PLACEMENT', 'Left Column', 'Should the module be loaded in the left or right column?', '6', '1', 'tep_cfg_select_option(array(\'Left Column\', \'Right Column\'), ', now())");
        tep_db_query("insert into " . TABLE_CONFIGURATION . " (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added) values ('Sort Order', 'MODULE_BOXES_CATEGORIES_SORT_ORDER', '0', 'Sort order of display. Lowest is displayed first.', '6', '0', now())");
    }

    function remove() {
        tep_db_query("delete from " . TABLE_CONFIGURATION . " where configuration_key in ('" . implode("', '", $this->keys()) . "')");
    }

    function keys() {
        return array('MODULE_BOXES_CATEGORIES_STATUS', 'MODULE_BOXES_CATEGORIES_CONTENT_PLACEMENT', 'MODULE_BOXES_CATEGORIES_SORT_ORDER');
    }
}
?>
